﻿CREATE TABLE [dbo].[ScheduleWeeklyProgress_Tbl] (
    [WeeklyProgressID]  INT   IDENTITY (1, 1) NOT NULL,
    [MasterID]          INT   NULL,
    [ProdWeek]          INT   NULL,
    [ProdYear]          INT   NULL,
    [OrderID]           INT   NULL,
    [LineItem]          INT   NULL,
    [MultipleNo]        INT   NOT NULL,
    [WorkProgressID]    INT   NULL,
    [CalcTotalHrs]      FLOAT NULL,
    [WeeklyValue]       FLOAT NULL,
    [CarryOverResidual] FLOAT NULL,
    [ResidualValue]     FLOAT NULL,
    [CompleteHrs]       FLOAT NULL,
    [ResidualHrs]       FLOAT NULL,
    [WeeksIntoProject]  INT   NULL,
    [Fixed]             BIT   NOT NULL,
    [CarryOver]         BIT   NOT NULL,
    [CarryOverValue]    FLOAT NULL
);

